<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/qq_41969284/article/details/80921965"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"python 怎么使用MySQL - qq_41969284的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>python 怎么使用MySQL - qq_41969284的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/qq_41969284\/article\/details\/80921965","appid":"1563894916825412","title":"python \u600e\u4e48\u4f7f\u7528MySQL - qq_41969284\u7684\u535a\u5ba2","images":["https:\/\/img-blog.csdn.net\/20180705100006277?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180705100549172?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180705100729792?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70"],"pubDate":"2019-08-09T15:10:06"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "qq_41969284";
        var blog_address = "https://blog.csdn.net/qq_41969284";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/qq_41969284/article/details/80921965"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "python 怎么使用MySQL";
        var articleDesc = "最近在学习数据入库的时候，遇到很多问题，作为新手的我很头疼。今天来总结一下。1、第一步下载数据库MySQL。这个简单，去官网下载就可以了。我当时下的是8.0版本，安装过程出现无数问题，都是泪啊。2、安装MySQL。我是官网下的mis格式文件，直接安装就安装好了。但是！！！在运行命令netstartmysql，连接数据库的时候，怎么都连接不上！！！百度了无数答案都没能解决，试了重装，删注册表等信...";
        // 第四范式所需数据
        var articleTitles = "python 怎么使用MySQL - qq_41969284的博客";
        
        var nickName = "会飛de鱼";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/qq_41969284/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/qq_41969284/article/details/80921965";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">python 怎么使用MySQL</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年07月05日 10:10:09</span>
                    <a class="follow-nickName" href="https://me.csdn.net/qq_41969284" target="_blank">会飛de鱼</a>
                    <span class="read-count">阅读数 2878</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            <p>最近在学习数据入库的时候，遇到很多问题，作为新手的我很头疼。今天来总结一下。</p><p>1、第一步下载数据库MySQL。这个简单，去官网下载就可以了。我当时下的是8.0版本，安装过程出现无数问题，都是泪啊。</p><p>2、安装MySQL。我是官网下的mis格式文件，直接安装就安装好了。但是！！！在运行命令net start mysql，连接数据库的时候，怎么都连接不上！！！百度了无数答案都没能解决，试了重装，删注册表等信息，再重装。都没能解决！！最后，没办法，只好把8.0的这版卸载干净，然后找了比较经典的MySQL57这个版本的安装，然后一下子就好了。什么问题都没有。以后就用它了！！！！！！</p><p>3、使用MySQL。作为新手的我，一开始是一脸懵逼的，完全不懂要怎么使用。我参考了一些资料，以及别人写数据入库是代码。总结了以下几点。</p><p>（1）我使用的是python，首先python装一个python-mysql库，直接在命令行pip install python-mysql就行了。然后，下载一个Navicat Premium（一个数据库可视化软件）在里面创建一个数据库并创建你想存入数据的表，给表添加你想存入的字段，然后保存。</p><p>（2）在你的代码里写一个方法，如：save_to_mysql()【这一步我以前是不懂的，不知道mysql语句到底要写在哪里，要怎么才能运行，是不是要在其他文件下写SQL语句创建表，字段等内容，然后再与代码之间有什么连接之类的。】第一步写连接数据库代码<img src="https://img-blog.csdn.net/20180705100006277?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" />数据库名为'test'。然后获取游标。</p><p>（3）写SQL语句</p><p><img src="https://img-blog.csdn.net/20180705100549172?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /></p><p>all_company是要插入的表的名字，VALUES()里是要插入的值【注意！%s要加''引号】</p><p>（4）<img src="https://img-blog.csdn.net/20180705100729792?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTY5Mjg0/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" />执行SQL语句，并提交。</p>                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_41969284/article/details/80921965","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_41969284/article/details/80921965","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="80921965">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/misterbobo/article/details/78290732","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/misterbobo/article/details/78290732" target="_blank" title="Python与数据库简单交互">
		<h4 class="text-truncate oneline">
				<em>Python</em>与数据库简单交互		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-19</span>
				<span class="read-num hover-hide">
					阅读数 
					3102</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/misterbobo/article/details/78290732" target="_blank" title="Python与数据库简单交互">
				<span class="desc oneline">本文档原文来自：http://www.runoob.com/python/python-mysql.htmlPythonDB-API使用流程尝试与数据库进行对接创建数据表在数据表中插入记录在数据表中查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/misterbobo">来自：	<span class="blog_title"> misterbobo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ruanxingzi123/article/details/83750246","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ruanxingzi123/article/details/83750246" target="_blank" title="python mysql">
		<h4 class="text-truncate oneline">
				<em>python</em> <em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1321</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ruanxingzi123/article/details/83750246" target="_blank" title="python mysql">
				<span class="desc oneline">一、python mysql使用实例 1、连接数据库如下：importpymysqlconn=pymysql.connect(host='127.0.0.1', port=3306,   user='...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ruanxingzi123">来自：	<span class="blog_title"> 一起学习</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhouzhiwengang/article/details/86800149","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhouzhiwengang/article/details/86800149" target="_blank" title="Python3 连接MySQL8">
		<h4 class="text-truncate oneline">
				<em>Python</em>3 连接<em>MySQL</em>8		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-09</span>
				<span class="read-num hover-hide">
					阅读数 
					485</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhouzhiwengang/article/details/86800149" target="_blank" title="Python3 连接MySQL8">
				<span class="desc oneline">第一步：安装pymysql，记住（大于python3.X）的版本：pipinstallpymysql第二步：验证pymysql是否安装成功：importpymysql#打开数据库连接#localhos...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhouzhiwengang">来自：	<span class="blog_title"> zhouzhiwengang的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/youzhouliu/article/details/81047057","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/youzhouliu/article/details/81047057" target="_blank" title="python对mysql的操作">
		<h4 class="text-truncate oneline">
				<em>python</em>对<em>mysql</em>的操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-14</span>
				<span class="read-num hover-hide">
					阅读数 
					1083</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/youzhouliu/article/details/81047057" target="_blank" title="python对mysql的操作">
				<span class="desc oneline">Mysql常见操作数据库操作创建数据库　　　　createdatabasefuzjtest删除数据库　　　　dropdatabasefuzjtest查询数据库　　　　showdatabases切换数据...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/youzhouliu">来自：	<span class="blog_title"> youzhouliu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Oscer2016/article/details/70257024","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Oscer2016/article/details/70257024" target="_blank" title="Python操作MySQL数据库的三种方法">
		<h4 class="text-truncate oneline">
				<em>Python</em>操作<em>MySQL</em>数据库的三种方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-20</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Oscer2016/article/details/70257024" target="_blank" title="Python操作MySQL数据库的三种方法">
				<span class="desc oneline">1.MySQLdb的使用(1)什么是MySQLdb？  MySQLdb是用于Python连接MySQL数据库的接口，它实现了Python数据库API规范V2.0，基于MySQLCAPI上建立的。(2)...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Oscer2016">来自：	<span class="blog_title"> HP的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_30486037/article/details/97478338","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30486037/article/details/97478338" target="_blank" title="MYSQL(一)">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>(一)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-13</span>
				<span class="read-num hover-hide">
					阅读数 
					3</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30486037/article/details/97478338" target="_blank" title="MYSQL(一)">
				<span class="desc oneline">mysql简介1、什么是数据库？数据库（Database）是按照数据结构来组织、存储和管理数据的仓库，它产生于距今六十多年前，随着信息技术和市场的发展，特别是二十世纪九十年代以后，数据管理不再仅仅是存...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30486037">来自：	<span class="blog_title"> weixin_30486037的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ems_2014/article/details/39274361","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ems_2014/article/details/39274361" target="_blank" title="Python中MySQLdb安装">
		<h4 class="text-truncate oneline">
				<em>Python</em>中<em>MySQL</em>db安装		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-14</span>
				<span class="read-num hover-hide">
					阅读数 
					276</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ems_2014/article/details/39274361" target="_blank" title="Python中MySQLdb安装">
				<span class="desc oneline">http://www.codegood.com/downloads注意自己的电脑系统版本和Python</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ems_2014">来自：	<span class="blog_title"> ems_2014的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42180610/article/details/87057625","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42180610/article/details/87057625" target="_blank" title="Python MySQL - mysql-connector驱动（26）">
		<h4 class="text-truncate oneline">
				<em>Python</em> <em>MySQL</em> - <em>mysql</em>-connector驱动（26）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-12</span>
				<span class="read-num hover-hide">
					阅读数 
					109</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42180610/article/details/87057625" target="_blank" title="Python MySQL - mysql-connector驱动（26）">
				<span class="desc oneline">PythonMySQL-mysql-connector驱动MySQL是最流行的关系型数据库管理系统，如果你不不熟悉MySQL，可以阅读我们的 MySQL教程。本章节我们为大家介绍使用 mysql-co...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42180610">来自：	<span class="blog_title"> weixin_42180610的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012269653/article/details/88060718","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012269653/article/details/88060718" target="_blank" title="Python3  链接 MySql">
		<h4 class="text-truncate oneline">
				<em>Python</em>3  链接 <em>MySql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-01</span>
				<span class="read-num hover-hide">
					阅读数 
					210</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012269653/article/details/88060718" target="_blank" title="Python3  链接 MySql">
				<span class="desc oneline">查阅了下关于python链接MySql的问题。一：Python要链接MySql首先需要去下载PyMySql包于行如下命令pip3installPyMySqL安装方式很多，根据喜好来二：安装MySql直...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012269653">来自：	<span class="blog_title"> u012269653的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qzqanzc/article/details/84256802","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qzqanzc/article/details/84256802" target="_blank" title="python 3.7 二： 操作 mysql">
		<h4 class="text-truncate oneline">
				<em>python</em> 3.7 二： 操作 <em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-19</span>
				<span class="read-num hover-hide">
					阅读数 
					706</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qzqanzc/article/details/84256802" target="_blank" title="python 3.7 二： 操作 mysql">
				<span class="desc oneline">pip3installpymysqlmysql_utils.pyimportpymysqlfrom..config.read_configimportConfigUtilclassMysqlUtils...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qzqanzc">来自：	<span class="blog_title"> qzqanzc的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_39012047/article/details/82154924","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_39012047/article/details/82154924" target="_blank" title="python+mysql">
		<h4 class="text-truncate oneline">
				<em>python</em>+<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-28</span>
				<span class="read-num hover-hide">
					阅读数 
					328</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_39012047/article/details/82154924" target="_blank" title="python+mysql">
				<span class="desc oneline">1.pip installPyMySQL   依赖包2.#打开数据库连接db=pymysql.connect(&amp;quot;localhost&amp;quot;,&amp;quot;root&amp;quot;,&amp;quot;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_39012047">来自：	<span class="blog_title"> weixin_39012047的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wys578/article/details/80632830","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wys578/article/details/80632830" target="_blank" title="mysql与Python交互">
		<h4 class="text-truncate oneline">
				<em>mysql</em>与<em>Python</em>交互		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-09</span>
				<span class="read-num hover-hide">
					阅读数 
					8501</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wys578/article/details/80632830" target="_blank" title="mysql与Python交互">
				<span class="desc oneline">增删改frompymysqlimport*defmain():#创建Connection连接conn=connect(host='localhost',port=3306,database='jing...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wys578">来自：	<span class="blog_title"> wys578的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Hang_shao98/article/details/82110924","strategy":"BlogCommendFromMachineLearnPai2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Hang_shao98/article/details/82110924" target="_blank" title="新手如何使用python3">
		<h4 class="text-truncate oneline">
				新手如何<em>使用</em><em>python</em>3		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2858</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Hang_shao98/article/details/82110924" target="_blank" title="新手如何使用python3">
				<span class="desc oneline">python3怎么使用呢？首先我们要先到官网下载一个python3官方下载地址在这里点击链接之后发现界面是这样的这时候点击Downloads选择Allreleases这时候会看到一个黄色的Downlo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Hang_shao98">来自：	<span class="blog_title"> Hang_shao98的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33722246/article/details/83829453","strategy":"BlogCommendFromMachineLearnPai2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33722246/article/details/83829453" target="_blank" title="Python操作MySql">
		<h4 class="text-truncate oneline">
				<em>Python</em>操作<em>MySql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-07</span>
				<span class="read-num hover-hide">
					阅读数 
					17</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33722246/article/details/83829453" target="_blank" title="Python操作MySql">
				<span class="desc oneline">连接：importpymysql#连接数据库db=pymysql.connect(host='localhost',user='root',password='123456')#print(db)#选...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33722246">来自：	<span class="blog_title"> qq_33722246的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zV3e189oS5c0tSknrBCL/article/details/78723181","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zV3e189oS5c0tSknrBCL/article/details/78723181" target="_blank" title="用 Python 连接 MySQL 的几种姿势">
		<h4 class="text-truncate oneline">
				用 <em>Python</em> 连接 <em>MySQL</em> 的几种姿势		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-05</span>
				<span class="read-num hover-hide">
					阅读数 
					279</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zV3e189oS5c0tSknrBCL/article/details/78723181" target="_blank" title="用 Python 连接 MySQL 的几种姿势">
				<span class="desc oneline">尽管很多NoSQL数据库近几年大放异彩，但是像MySQL这样的关系型数据库依然是互联网的主流数据库之一，每个学Python的都有必要学好一门数据库，不管你是做数据分析，还是网络爬虫，Web开发、亦或是...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zV3e189oS5c0tSknrBCL">来自：	<span class="blog_title"> Python之禅</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/panyueke/article/details/86482823","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/panyueke/article/details/86482823" target="_blank" title="python怎么操作mysql">
		<h4 class="text-truncate oneline">
				<em>python</em><em>怎么</em>操作<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-14</span>
				<span class="read-num hover-hide">
					阅读数 
					297</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/panyueke/article/details/86482823" target="_blank" title="python怎么操作mysql">
				<span class="desc oneline">python怎么操作mysql?先附一段代码：importpymysqlimportredisimportdatetimedeftruncateDateBase():connect=pymysql.C...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/panyueke">来自：	<span class="blog_title"> KellyPan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_40947719/article/details/86323073","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_40947719/article/details/86323073" target="_blank" title="关于python3.7下安装MySQL-python模块的问题">
		<h4 class="text-truncate oneline">
				关于<em>python</em>3.7下安装<em>MySQL</em>-<em>python</em>模块的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-12</span>
				<span class="read-num hover-hide">
					阅读数 
					2723</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_40947719/article/details/86323073" target="_blank" title="关于python3.7下安装MySQL-python模块的问题">
				<span class="desc oneline"> 最近看视频学习接口自动化测试框架时涉及到数据库相关操作的课程时，老师是在安装的MySQL-python，于是百度了找到官网：https://pypi.org/project/MySQL-python...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_40947719">来自：	<span class="blog_title"> weixin_40947719的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cwy0502/article/details/92645792","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cwy0502/article/details/92645792" target="_blank" title="python_python连接至MySQL">
		<h4 class="text-truncate oneline">
				<em>python</em>_<em>python</em>连接至<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-17</span>
				<span class="read-num hover-hide">
					阅读数 
					381</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cwy0502/article/details/92645792" target="_blank" title="python_python连接至MySQL">
				<span class="desc oneline">PyMySQLMySQL可应用于多种语言，可以使用Python来连接和操作MySQL数据库什么是PyMySQL？1、PyMySQL是在Python3.x版本中用于连接MySQL数据库的一个python...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cwy0502">来自：	<span class="blog_title"> cwy0502的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qwerLoL123456/article/details/80904128","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qwerLoL123456/article/details/80904128" target="_blank" title="Python操作mysql">
		<h4 class="text-truncate oneline">
				<em>Python</em>操作<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-03</span>
				<span class="read-num hover-hide">
					阅读数 
					498</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qwerLoL123456/article/details/80904128" target="_blank" title="Python操作mysql">
				<span class="desc oneline">想要用Python操作mysql需要引入pymysql模块1.下面是一个用Python写的简单的mysql查询操作#导入pymysql模块importpymysql#获取连接coon=pymysql....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qwerLoL123456">来自：	<span class="blog_title"> qwerLoL123456的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Jerry_1126/article/details/80872379","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Jerry_1126/article/details/80872379" target="_blank" title="Python2 和 3访问MySQL数据库">
		<h4 class="text-truncate oneline">
				<em>Python</em>2 和 3访问<em>MySQL</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-01</span>
				<span class="read-num hover-hide">
					阅读数 
					2330</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Jerry_1126/article/details/80872379" target="_blank" title="Python2 和 3访问MySQL数据库">
				<span class="desc oneline">Python2和3访问MySQL使用的模块不同，2使用MySQLdb模块，而3使用pymysql模块，其他相差不大。Python3连接MySQL数据库代码:importpymysql#创建一个连接对象...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Jerry_1126">来自：	<span class="blog_title"> 杰瑞的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_32393347/article/details/93158273","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_32393347/article/details/93158273" target="_blank" title="python：MySQL-python 增删改查">
		<h4 class="text-truncate oneline">
				<em>python</em>：<em>MySQL</em>-<em>python</em> 增删改查		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					24</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_32393347/article/details/93158273" target="_blank" title="python：MySQL-python 增删改查">
				<span class="desc oneline">文章目录链接数据库python：MySQL-python增删改查链接数据库importmysql.connectormydb=mysql.connector.connect(host=&quot;localho...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_32393347">来自：	<span class="blog_title"> 小禅：缠者，人性之纠结，贪嗔疾慢疑也；禅者，觉悟、超脱者也。</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yi247630676/article/details/83376607","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yi247630676/article/details/83376607" target="_blank" title="使用Python调用mysql-python模块失败经验总结">
		<h4 class="text-truncate oneline">
				<em>使用</em><em>Python</em>调用<em>mysql</em>-<em>python</em>模块失败经验总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-25</span>
				<span class="read-num hover-hide">
					阅读数 
					351</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yi247630676/article/details/83376607" target="_blank" title="使用Python调用mysql-python模块失败经验总结">
				<span class="desc oneline">最近一直在花时间研究Python语言，刚好自己装了mysql想使用原Cent764里面的Python调用数据。思路：1.查看Python支持不支持。2.装载模块所需要的依赖包。3安装Mysql-pyt...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yi247630676">来自：	<span class="blog_title"> 美国梦中国心</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37788558/article/details/80814524","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_37788558/article/details/80814524" target="_blank" title="pymysql的安装及使用">
		<h4 class="text-truncate oneline">
				py<em>mysql</em>的安装及<em>使用</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_37788558/article/details/80814524" target="_blank" title="pymysql的安装及使用">
				<span class="desc oneline">Python具有内置的SQLite支持。在本节中，我们将学习使用MySQL的相关概念和知识。在早期Python版本一般都使用MySQLdb模块，但这个MySQL的流行接口与Python3不兼容。因此，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_37788558">来自：	<span class="blog_title"> 小白成神路</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Man_Lucifer/article/details/82962116","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Man_Lucifer/article/details/82962116" target="_blank" title="python使用占位符">
		<h4 class="text-truncate oneline">
				<em>python</em><em>使用</em>占位符		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-07</span>
				<span class="read-num hover-hide">
					阅读数 
					125</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Man_Lucifer/article/details/82962116" target="_blank" title="python使用占位符">
				<span class="desc oneline">用法和c语言基本相似如：print(&amp;amp;quot;[*]PID:%d&amp;amp;quot;%process_information.dwProceessID)	（注意&amp;amp;quot;&amp;amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Man_Lucifer">来自：	<span class="blog_title"> Man_Lucifer的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/juliarjuliar/article/details/82148129","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/juliarjuliar/article/details/82148129" target="_blank" title="基于python的mysql安装">
		<h4 class="text-truncate oneline">
				基于<em>python</em>的<em>mysql</em>安装		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-28</span>
				<span class="read-num hover-hide">
					阅读数 
					879</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/juliarjuliar/article/details/82148129" target="_blank" title="基于python的mysql安装">
				<span class="desc oneline">.msi文件下载：https://dev.mysql.com/downloads/installer/zip文件下载：https://dev.mysql.com/downloads/mysql/安装链...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/juliarjuliar">来自：	<span class="blog_title"> juliarjuliar的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chengqiuming/article/details/78601227","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chengqiuming/article/details/78601227" target="_blank" title="python的mysql数据库插入数据">
		<h4 class="text-truncate oneline">
				<em>python</em>的<em>mysql</em>数据库插入数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-22</span>
				<span class="read-num hover-hide">
					阅读数 
					7951</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chengqiuming/article/details/78601227" target="_blank" title="python的mysql数据库插入数据">
				<span class="desc oneline">一代码importpymysql#打开数据库连接db=pymysql.connect(&quot;localhost&quot;,&quot;root&quot;,&quot;root&quot;,&quot;db_test01&quot;)#使用cursor()方法获取操作游标...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chengqiuming">来自：	<span class="blog_title"> 实践求真知</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaobao5214/article/details/82712778","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaobao5214/article/details/82712778" target="_blank" title="python-连接MySQL（mysql.connector与MySQLdb区别）">
		<h4 class="text-truncate oneline">
				<em>python</em>-连接<em>MySQL</em>（<em>mysql</em>.connector与<em>MySQL</em>db区别）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-15</span>
				<span class="read-num hover-hide">
					阅读数 
					2144</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaobao5214/article/details/82712778" target="_blank" title="python-连接MySQL（mysql.connector与MySQLdb区别）">
				<span class="desc oneline"> 1.安装mysql-connector 命令  pipinstallmysql-connector importmysql.connectorcnx=mysql.connector.connect(...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaobao5214">来自：	<span class="blog_title"> xiaobao5214的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42578658/article/details/92622999","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42578658/article/details/92622999" target="_blank" title="python与mysql">
		<h4 class="text-truncate oneline">
				<em>python</em>与<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-17</span>
				<span class="read-num hover-hide">
					阅读数 
					21</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42578658/article/details/92622999" target="_blank" title="python与mysql">
				<span class="desc oneline">链接，插入数据importpymysqlconn=pymysql.connect(host='localhost',user='root',passwd='root',db='mydb',port=3...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42578658">来自：	<span class="blog_title"> sunshine博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/userez/article/details/79243258","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/userez/article/details/79243258" target="_blank" title="python（11-6 python 连接数据库 及 增删改查）">
		<h4 class="text-truncate oneline">
				<em>python</em>（11-6 <em>python</em> 连接数据库 及 增删改查）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1133</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/userez/article/details/79243258" target="_blank" title="python（11-6 python 连接数据库 及 增删改查）">
				<span class="desc oneline">Python3MySQL数据库连接MySQL可应用于多种语言，包括PERL,C,C++,JAVA和PHP什么是PyMySQL？PyMySQL是在Python3.x版本中用于连接MySQL服务器的一个库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/userez">来自：	<span class="blog_title"> userez的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_41710606/article/details/86495155","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_41710606/article/details/86495155" target="_blank" title="python连接mysql获取带列名的数据">
		<h4 class="text-truncate oneline">
				<em>python</em>连接<em>mysql</em>获取带列名的数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-15</span>
				<span class="read-num hover-hide">
					阅读数 
					1423</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_41710606/article/details/86495155" target="_blank" title="python连接mysql获取带列名的数据">
				<span class="desc oneline">importpymysqldefdata_out_sql(DB,sql):conn=pymysql.connect(host=DB['host'],port=DB['port'],user=DB['u...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_41710606">来自：	<span class="blog_title"> weixin_41710606的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/guoll123/article/details/79716542","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/guoll123/article/details/79716542" target="_blank" title="python批量向MySQL中插入数据">
		<h4 class="text-truncate oneline">
				<em>python</em>批量向<em>MySQL</em>中插入数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-27</span>
				<span class="read-num hover-hide">
					阅读数 
					4415</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/guoll123/article/details/79716542" target="_blank" title="python批量向MySQL中插入数据">
				<span class="desc oneline">#-*-coding:utf-8-*-importjsonimportpymysqlforminrange(1,225):   file='F:\\pins_two\\user_xinxi\\pins...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/guoll123">来自：	<span class="blog_title"> guoll123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Rivalsx/article/details/90727911","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Rivalsx/article/details/90727911" target="_blank" title="10分钟教你Python+MySQL数据库操作">
		<h4 class="text-truncate oneline">
				10分钟教你<em>Python</em>+<em>MySQL</em>数据库操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-01</span>
				<span class="read-num hover-hide">
					阅读数 
					82</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Rivalsx/article/details/90727911" target="_blank" title="10分钟教你Python+MySQL数据库操作">
				<span class="desc oneline">欲直接下载代码文件，关注我们的公众号哦！查看历史消息即可！本文介绍如何利用python来对MySQL数据库进行操作，本文将主要从以下几个方面展开介绍：1.数据库介绍2.MySQL数据库安装和设置3.P...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Rivalsx">来自：	<span class="blog_title"> infinitor的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zs15321583801/article/details/80549060","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zs15321583801/article/details/80549060" target="_blank" title="安装MySQL+python链接MySQL">
		<h4 class="text-truncate oneline">
				安装<em>MySQL</em>+<em>python</em>链接<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-03</span>
				<span class="read-num hover-hide">
					阅读数 
					2196</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zs15321583801/article/details/80549060" target="_blank" title="安装MySQL+python链接MySQL">
				<span class="desc oneline">参考：python操作mysql数据库1.数据库链接</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zs15321583801">来自：	<span class="blog_title"> 棒子皮蹦蹦床</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012063703/article/details/46916661","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012063703/article/details/46916661" target="_blank" title="Python3  支持 MySQL">
		<h4 class="text-truncate oneline">
				<em>Python</em>3  支持 <em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-16</span>
				<span class="read-num hover-hide">
					阅读数 
					778</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012063703/article/details/46916661" target="_blank" title="Python3  支持 MySQL">
				<span class="desc oneline">其实就两句:yuminstallpython-pip#pipinstallpymysql</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012063703">来自：	<span class="blog_title"> kunpengku </span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xbw_linux123/article/details/81215991","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xbw_linux123/article/details/81215991" target="_blank" title="python中的mysql数据库管理和socket">
		<h4 class="text-truncate oneline">
				<em>python</em>中的<em>mysql</em>数据库管理和socket		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-26</span>
				<span class="read-num hover-hide">
					阅读数 
					110</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xbw_linux123/article/details/81215991" target="_blank" title="python中的mysql数据库管理和socket">
				<span class="desc oneline">下载包，导入包yuminstallmariadb-server.x86_64-yyuminstallgcc-yyumsearchmysql-pythonyuminstallMySQL-python.x...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xbw_linux123">来自：	<span class="blog_title"> xbw_linux123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_41782332/article/details/80354710","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_41782332/article/details/80354710" target="_blank" title="python环境下对mysql操作">
		<h4 class="text-truncate oneline">
				<em>python</em>环境下对<em>mysql</em>操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					136</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_41782332/article/details/80354710" target="_blank" title="python环境下对mysql操作">
				<span class="desc oneline">python里面操作mysql时连接可能报错：ex:cannotconnnect...-host写错-port写错-服务器没启动ex:unknowndatabase...-db/databaseex:...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_41782332">来自：	<span class="blog_title"> GO_Print的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chengyinman0078/article/details/90407625","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chengyinman0078/article/details/90407625" target="_blank" title="Python学习之路---Mysql操作">
		<h4 class="text-truncate oneline">
				<em>Python</em>学习之路---<em>Mysql</em>操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					29</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chengyinman0078/article/details/90407625" target="_blank" title="Python学习之路---Mysql操作">
				<span class="desc oneline">MySQL--基础安装安装注意事项：1、先将目录添加到Path中；(解决在CMD运行mysql时不是内部的可运行命令)2、初始化MySQL（cmd:mysqld--initialize-insecur...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chengyinman0078">来自：	<span class="blog_title"> chengyinman0078的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_31235811/article/details/90520293","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_31235811/article/details/90520293" target="_blank" title="MySQL基本操作">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>基本操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-24</span>
				<span class="read-num hover-hide">
					阅读数 
					41</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_31235811/article/details/90520293" target="_blank" title="MySQL基本操作">
				<span class="desc oneline">文章目录MYSQL操作数据库操作表属性方法数据类型：数字：字符串：时间类型	字节	格式enum枚举set集合自增起始值修改自增步长语句操作外键：省内存分析步骤：连表操作MYSQLWindows10安装...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_31235811">来自：	<span class="blog_title"> Python学习之旅</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_43445668/article/details/84111157","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/m0_43445668/article/details/84111157" target="_blank" title="python写入MySQL数据库">
		<h4 class="text-truncate oneline">
				<em>python</em>写入<em>MySQL</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-15</span>
				<span class="read-num hover-hide">
					阅读数 
					2410</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/m0_43445668/article/details/84111157" target="_blank" title="python写入MySQL数据库">
				<span class="desc oneline">这次给大家带来的是将python爬取的数据写入数据库将爬取得数据写入数据库的步骤：连接数据库；创建表将数据写入数据库；关闭数据库。1.连接数据库在连接自己的数据库之前我们应先导入importMySQL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/m0_43445668">来自：	<span class="blog_title"> m0_43445668的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34908107/article/details/80925344","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34908107/article/details/80925344" target="_blank" title="Python-MySQL存储">
		<h4 class="text-truncate oneline">
				<em>Python</em>-<em>MySQL</em>存储		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-05</span>
				<span class="read-num hover-hide">
					阅读数 
					636</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34908107/article/details/80925344" target="_blank" title="Python-MySQL存储">
				<span class="desc oneline">前言今天我们讲一下MySQL的存储。我们先做好准备工作，也就是安装MySQL和PyMySQL。MySQL安装直接看我之前写的文章就可以了，链接为：MySQL数据库-安装PyMySQL的安装：通过PIP...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34908107">来自：	<span class="blog_title"> 秦子帅的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/weixin_38669628/10995926","strategy":"BlogCommendFromBaidu","index":"40"}'>
		<a href="https://download.csdn.net/download/weixin_38669628/10995926" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						初试<em>Python</em> 操作<em>Mysql</em>					</h4>
					<span class="data float-right">03-05</span>
				</div>
				<div class="desc oneline">
						博文链接：https://23c.iteye.com/blog/191127				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wangyajie_11/article/details/54134526","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wangyajie_11/article/details/54134526" target="_blank" title="Python在mysql中进行操作是十分容易和简洁的">
		<h4 class="text-truncate oneline">
				<em>Python</em>在<em>mysql</em>中进行操作是十分容易和简洁的		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wangyajie_11/article/details/54134526" target="_blank" title="Python在mysql中进行操作是十分容易和简洁的">
				<span class="desc oneline">首先声明一下，我用的是Windows系统！1、在Python中对mysql数据库进行操作首先要导入pymysql模块，默认情况下，Python中是没有安装这个模块的，可以在Windows的命令行中用p...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wangyajie_11">来自：	<span class="blog_title"> wangyajie_11的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/YMD8005/article/details/79281133","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/YMD8005/article/details/79281133" target="_blank" title="python安装mysql-python或者python安装mysqlclient">
		<h4 class="text-truncate oneline">
				<em>python</em>安装<em>mysql</em>-<em>python</em>或者<em>python</em>安装<em>mysql</em>client		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/YMD8005/article/details/79281133" target="_blank" title="python安装mysql-python或者python安装mysqlclient">
				<span class="desc oneline">python安装mysql-python或者python安装mysqlclient报错：  C:\Users\John\AppData\Local\Programs\Common\Microsoft\...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/YMD8005">来自：	<span class="blog_title"> YMD8005的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hbclc/article/details/1774705","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hbclc/article/details/1774705" target="_blank" title="VC 点滴 之 重绘">
		<h4 class="text-truncate oneline">
				VC 点滴 之 重绘		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-06</span>
				<span class="read-num hover-hide">
					阅读数 
					550</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hbclc/article/details/1774705" target="_blank" title="VC 点滴 之 重绘">
				<span class="desc oneline"> 基本知识：1．OnPaint和OnDraw函数View的父类的OnPaint函数调用了OnDraw函数，若在子类为WM_PAINT消息添加响应函数OnPaint，OnDraw函数将不会被调用。2．C...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"http://ask.csdn.net/questions/707297","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<a href="http://ask.csdn.net/questions/707297" target="_blank">
		<h4 class="text-truncate oneline">
				如何<em>使用</em> <em>Python</em> 连接 <em>MySQL</em> 数据库？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-16</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/dragonrxl/article/details/60571040","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/dragonrxl/article/details/60571040" target="_blank" title="mysql默认8小时超时设置的修改">
		<h4 class="text-truncate oneline">
				<em>mysql</em>默认8小时超时设置的修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-02</span>
				<span class="read-num hover-hide">
					阅读数 
					3041</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/dragonrxl/article/details/60571040" target="_blank" title="mysql默认8小时超时设置的修改">
				<span class="desc oneline">两种解决办法:1,设置定时器，每隔几个小时请求一次数据库，如果使用框架的话可以打开相应设置。2,修改mysql的默认超时时间。这里介绍第二种方法简单记录下，有两种途径来设置mysql的超时时间第一种途...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/dragonrxl">来自：	<span class="blog_title"> dragonrxl的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/douyunqian668/article/details/51505822","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/douyunqian668/article/details/51505822" target="_blank" title="Python操作Mysql">
		<h4 class="text-truncate oneline">
				<em>Python</em>操作<em>Mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-26</span>
				<span class="read-num hover-hide">
					阅读数 
					282</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/douyunqian668/article/details/51505822" target="_blank" title="Python操作Mysql">
				<span class="desc oneline">#coding=utf-8importxlwt,MySQLdb#第一步创建连接coon=MySQLdb.connect(host='127.0.0.1',user='host',passwd='',d...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/douyunqian668">来自：	<span class="blog_title"> douyunqian668的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/suibianlasa/article/details/86421303","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/suibianlasa/article/details/86421303" target="_blank" title="使用Python给Mysql数据库表去重以及排序">
		<h4 class="text-truncate oneline">
				<em>使用</em><em>Python</em>给<em>Mysql</em>数据库表去重以及排序		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-13</span>
				<span class="read-num hover-hide">
					阅读数 
					489</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/suibianlasa/article/details/86421303" target="_blank" title="使用Python给Mysql数据库表去重以及排序">
				<span class="desc oneline">1</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/suibianlasa">来自：	<span class="blog_title"> suibianlasa的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/km_moon/article/details/84689821","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/km_moon/article/details/84689821" target="_blank" title="python mysql查询条件带变量方法">
		<h4 class="text-truncate oneline">
				<em>python</em> <em>mysql</em>查询条件带变量方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-06</span>
				<span class="read-num hover-hide">
					阅读数 
					191</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/km_moon/article/details/84689821" target="_blank" title="python mysql查询条件带变量方法">
				<span class="desc oneline">python对mysql数据库进行，查询、更新、删除条件，添加变量的方法方法一：网上大多能搜索到的是拼接字符串的形式，方法如下：testcase_id=cur.execute('select*from...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/km_moon">来自：	<span class="blog_title"> 记录点滴</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iyeahme/article/details/48314831","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iyeahme/article/details/48314831" target="_blank" title="Python的AOP利器:装饰器">
		<h4 class="text-truncate oneline">
				<em>Python</em>的AOP利器:装饰器		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-09</span>
				<span class="read-num hover-hide">
					阅读数 
					4312</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iyeahme/article/details/48314831" target="_blank" title="Python的AOP利器:装饰器">
				<span class="desc oneline">面向对象（OOP）的目的在于抽象,而面向切面（AOP）的目的在于解耦。在Java中面向切面编程需要使用反射（动态代理）实现，操作比较麻烦。而在Python语言中则提供了一个很好用的语法糖–装饰器....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iyeahme">来自：	<span class="blog_title"> 不明飞行物</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/OtDaEgtsZWR1.html" target="_blank">
                        使用python教程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtTaUgysOC1lZHUO0O0O.html" target="_blank">
                        python教程类的使用</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/qq_41969284">
              <img src="https://avatar.csdn.net/A/4/E/3_qq_41969284.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/1.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/qq_41969284"  class="" id="uid">会飛de鱼</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="10">
                        <dt><a href="https://blog.csdn.net/qq_41969284?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/qq_41969284?t=1"><span class="count">10</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="4">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">4</span></dd>
        </dl>
        <dl class="text-center" title="5">
            <dt>喜欢</dt>
            <dd><span class="count">5</span></dd>
        </dl>
        <dl class="text-center" title="0">
            <dt>评论</dt>
            <dd><span class="count">0</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="7182">
                7182            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="175">
                175            </dd>
        </dl>
        <dl title="1135937">
            <dt>排名：</dt>
            <dd>113万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/qq_41969284">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_41969284/article/details/89204122" target="_blank" >
                                        python+selenium实现自动注册账号及过极验滑动验证经验分享                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_41969284/article/details/88186031" target="_blank" >
                                        面试算法题:输入金额，输入若干商品价格，买尽可能多的种类商品python实现                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_41969284/article/details/87281860" target="_blank" >
                                        python反反爬技巧之解密cookie                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_41969284/article/details/80921879" target="_blank" >
                                        网页爬虫---scrapy进阶                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_41969284/article/details/80755378" target="_blank" >
                                        爬虫翻页技巧                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_41969284/article/category/7747333">
                    <span class="title oneline">爬虫技巧</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_41969284/article/category/7779046">
                    <span class="title oneline">scrapy技巧</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_41969284/article/category/8847886">
                    <span class="title oneline">验证码</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2019/04">
                    2019年4月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2019/03">
                    2019年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2019/02">
                    2019年2月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2018/07">
                    2018年7月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2018/06">
                    2018年6月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_41969284/article/month/2018/04">
                    2018年4月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">1</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/qq_41969284/article/details/80921879" title="网页爬虫---scrapy进阶">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/qq_41969284/article/details/87281860" title="python反反爬技巧之解密cookie">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/qq_41969284/article/details/80921879" title="网页爬虫---scrapy进阶">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/qq_41969284/article/details/87281860" title="python反反爬技巧之解密cookie">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "80921965";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/qq_41969284/article/details/80921965";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "python 怎么使用MySQL - qq_41969284的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["python","\u600e\u4e48","\u4f7f\u7528","mysql"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
